BEGIN;

DROP DATABASE IF EXISTS `info`;
CREATE DATABASE `info`;
ALTER DATABASE `info` CHARACTER SET utf8;

USE `info`;

DROP TABLE IF EXISTS `instructors`;
CREATE TABLE instructors (
  `id` INT UNSIGNED NOT NULL auto_increment,
  `username` VARCHAR(64) NULL,
  `created_at` DATETIME NOT NULL,
  `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

COMMIT;